Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Shouldnt €˜UserInterfaceOnly:=True allow macros to change the sheet?
My worksheet has a Shape which moves to align with Column V when a macro is run. It works while the sheet is unprotected but when its protected, the macro fails (Run-time error 1004) even though protection was set for User Interface Only. The 'Protect' macro uses this code: Sheets("Name").Protect Password:="password", UserInterfaceOnly:=True, Contents:=True, DrawingObjects:=True The 'Move' macro which aligns the drawing object selects it and uses this code: Selection.Left = .Columns("V").Left I know I could add code at the beginning and end of €˜Move to Unprotect and Protect the sheet, but I thought that with €˜UserInterfaceOnly:=True, I should not need to do this? -- Kasama |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
protected work sheet | Excel Discussion (Misc queries) | |||
Protected work sheet | Excel Discussion (Misc queries) | |||
If I have a work sheet protected and try to run a macro to hide rows or columns it won't work. Correct? | Excel Programming | |||
Strange problems with setting hidden property of a range when sheet protected with UserInterfaceOnly | Excel Programming | |||
Macro protected work sheet | Excel Programming |