Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Setting EnableResize = False
Hello,
I opened a new insatnce of Excel and then I put the followinf code in the auto_open function Sub auto_open ActiveWindow.EnableResize = False Exit Sub And then I saved the file and closed it. When I tried to open it I got a run-time error message: Application-defined or object-defined error Did I make something wrong. I don't want the user to be able to resize the active window in Excel. What should I do? Thanks, --Bita |
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) | |||
Setting a CheckBox Value to False | Excel Programming | |||
Apply "EnableResize" to Application? | Excel Programming | |||
VBA Setting .Value to a date does not respect local system setting | Excel Programming | |||
True Or False, no matter what... it still displays the false statement | Excel Programming |