#1
|
|||
|
|||
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 |
#2
|
||||
|
||||
Use the UserInterfaceOnly parameter when you protect the sheet in the code.
|
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 |
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 |