Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
ThisWorkbook.Saved = True does not work when Shapes().ControlFormat.Enabled = False
Hello -
I am trying to figure out why I cannot set the ThisWorkbook.Saved values to True to avoid being prompted whether I want to save the workbook upon exiting. The code is doing the following ... Workbook_Open() Application.OnTime Now, "preProcess" ... Public Sub preProcess() If ThisWorkbook.ReadOnly Then ThisWorkbook.Sheets("Sheet1").Shapes("Button1").Co ntrolFormat.Enabled = False ThisWorkbook.Saved = True End If ... If I open the file in read-only and close it without making any changes, I get the "Do you want to save changes ..." message. All I want to do is to disable the button when the file is read-only. How can I tell Excel that it should not care whether the button has changed? I use Excel 11 (2003) SP2. Thanks! Joe |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
What's the best way to toggle between true and false in Excel? Hiall, My excel work involves a lot of toggling between true and false (booleantypes) ... and it's very repetitive... Is there a way to select a bunch ofcells, and press a key short-cu | Excel Discussion (Misc queries) | |||
Shapes.visible = false/true | Excel Programming | |||
Can I disable a macro in "Thisworkbook" with true or false? | Excel Programming | |||
Enabled Property of Shapes? | Excel Programming | |||
ThisWorkbook.Saved does not work! | Excel Programming |