excel protection
Can anyone help me out with an excel protection problem. I have a macro that
enters a number into a cell when a check box is clicked, however, the macro doesn't work when I place protection on this cell. Is there any way around this? I need to protect the cell , but I also need the macro to work. any help would be appreciated. -- Regards, timmulla |
excel protection
There are a couple of ways to do this
This protects the sheet from the actions of the users but not from macros. The assumption here is that you will be applying the protection via code... Sheet1.protect UserInterfaceonly:= True or Unprotect... do your stuff... re-protect Sheet1.Unprotect 'your code here Sheet1.Protect -- HTH... Jim Thomlinson "timmulla" wrote: Can anyone help me out with an excel protection problem. I have a macro that enters a number into a cell when a check box is clicked, however, the macro doesn't work when I place protection on this cell. Is there any way around this? I need to protect the cell , but I also need the macro to work. any help would be appreciated. -- Regards, timmulla |
All times are GMT +1. The time now is 06:14 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com