Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Hello -
I posted this question before but I have narrowed down what the problem is. I have a workbook with a button that I want to disable when it is opened in read-only (just to prevent people from pressing it). So I use If ThisWorkbook.ReadOnly Then ThisWorkbook.Sheets("Sheet1").Shapes(1).ControlFor mat.Enabled = False The problem is that this somehow triggers Excel to detect a change and as whether to save the workbook upon closing. I used ThisWorkbook.Saved = True after this but it did not make a difference. I even used the Application.EnableEvents = False/True around it. Any ideas? Thanks, Joe |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
In Excel 2003 is there a way to prevent "Save As" and "Print"? | Excel Discussion (Misc queries) | |||
Disabling "SAVE AS" option under "File" | Excel Discussion (Misc queries) | |||
If changed array formula reduce ""\""\""\ - signs to #Missing, will it make ... | Excel Programming | |||
prevent Excel from popping-up an "OK" (information) message | Excel Programming | |||
Prevent "XYZ.doc is locked for editing" message | Excel Programming |