Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 02-24-2019, 01:38 AM
DIMI DIMI is offline Protect sheets Windows 7 32bit Protect sheets Office 2007
Advanced Beginner
Protect sheets
 
Join Date: Aug 2017
Posts: 37
DIMI is on a distinguished road
Default Protect sheets

Good evening,


I have an excel sheet with invoice form, which I hope with the appropriate macros and store it on another sheet in a list format along with the other invoices I appreciate. In the list of invoices, because there is a risk that I can erase a item from previous entries, I have protected the sheet, so when I run the macro to issue my new invoice, it sends an error message due to protection.

How can I fix it?

Thank you
Reply With Quote
  #2  
Old 02-24-2019, 07:02 AM
p45cal's Avatar
p45cal p45cal is online now Protect sheets Windows 10 Protect sheets Office 2016
Expert
 
Join Date: Apr 2014
Posts: 863
p45cal has a brilliant futurep45cal has a brilliant futurep45cal has a brilliant futurep45cal has a brilliant futurep45cal has a brilliant futurep45cal has a brilliant futurep45cal has a brilliant futurep45cal has a brilliant futurep45cal has a brilliant futurep45cal has a brilliant futurep45cal has a brilliant future
Default

Use the UserInterfaceOnly parameter when you protect the sheet in the code.
Reply With Quote
Reply

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
can you protect only one line parshla Excel 2 09-11-2016 03:51 PM
How to manage some sheets and sub-sheets? tesoke Excel 6 11-15-2015 04:54 AM
Protect sheets Need to protect my name in a presentation! SuperMario PowerPoint 1 02-21-2015 09:09 AM
Linking sheets to fetch transactions from sheets to another waqer Excel 4 09-01-2011 12:35 PM
How to protect project? Prabhakar Project 1 05-17-2011 07:39 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 05:20 AM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2024, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2024 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft