Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Unlocking Macro in protected sheet
A simple question: - I have a rather large sheet with a lot of data in it. - In order to simplify sorting I recorded a few macros. - Since it is for government use I know a lot of people will be using it who don't know how not to change data that shouldn't be changed, I have protected the sheet. - Before locking the sheet I changed the properties of the cells that they should be able to change, unchecking the lock box. - When running the simple sorting macro VB tells me that I need to unlock the sheet even though the cells containing the macros are unlocked. Anyone got a tip on how I can get around this? I.e. I need to have the sheet protected while at the same time I want the macros activated. -- mag7417 ------------------------------------------------------------------------ mag7417's Profile: http://www.excelforum.com/member.php...o&userid=28413 View this thread: http://www.excelforum.com/showthread...hreadid=480088 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Unlocking Macro in protected sheet
Your macro may be trying to update cells in your worksheet. It will not be able to do this if these cells are locked. e.g. If your macro carrys out a goal seek, changing one cell to match another, it will only do this if the cell it needs to change is not protected. i.e. it can write to this cell. Therefore what you need to do is unlock any cells which your macro needs to write to. Hope this helps. -- Sprout ------------------------------------------------------------------------ Sprout's Profile: http://www.excelforum.com/member.php...o&userid=26411 View this thread: http://www.excelforum.com/showthread...hreadid=480088 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Unlocking a protected sheet | Excel Discussion (Misc queries) | |||
Unlocking Protected Cells | Excel Worksheet Functions | |||
Unlocking Macro in protected sheet | Excel Programming | |||
Unlocking pwd protected vba modules | Excel Programming | |||
Unlocking protected Sheet from ASP.NET | Excel Programming |