Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Code cancels protection properties
Hi all,
Have a small prob. I run a code that unprotects then protects a shee after running a copy/paste procedure. Prob is, after the code runs, am no longer able to delete rows. Before the code ran i set th protection to allow deletion of rows but running the code seems t cancel this. Is there a way round this?? Cheers all! -- Message posted from http://www.ExcelForum.com |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Code cancels protection properties
gavmer
After you run your code does it reset the password to protect th sheet? If so you can not delete rows Charle -- Message posted from http://www.ExcelForum.com |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Code cancels protection properties
Hi charles,
Yes, it uses the password to unprotect and then uses the password t protect the sheet once again. How can i get around this?? Cheers! -- Message posted from http://www.ExcelForum.com |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Code cancels protection properties
Hi,
When you re-protect the sheet are you using ActiveSheet.Protect UserInterFaceOnly := True regards, Don "gavmer " wrote in message ... Hi all, Have a small prob. I run a code that unprotects then protects a sheet after running a copy/paste procedure. Prob is, after the code runs, i am no longer able to delete rows. Before the code ran i set the protection to allow deletion of rows but running the code seems to cancel this. Is there a way round this?? Cheers all!! --- Message posted from http://www.ExcelForum.com/ |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
I am using a macro and it cancels my formula | Excel Worksheet Functions | |||
Button properties blank: protection problem? | Excel Discussion (Misc queries) | |||
how view a WS code/properties | Excel Programming | |||
VBA code delete code but ask for password and unlock VBA protection | Excel Programming | |||
File Properties Code | Excel Programming |