| 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 |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Setting EnableResize = False
You want End Sub not Exit Sub.
The code should work as long as there is an active window. For instance, if it's hidden for any reason it will fail. -- Jim "BIta" wrote in message ups.com... | 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 | |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Setting EnableResize = False
Sorry, I meant End Sub.
|
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Setting EnableResize = False
Oh, yeah I just remembered the reason that line fails - the window is
maximized! You have to use the WindowState property and set it to xlNormal before you can set EnableResize. -- Jim "Jim Rech" wrote in message ... | You want End Sub not Exit Sub. | | The code should work as long as there is an active window. For instance, if | it's hidden for any reason it will fail. | | -- | Jim | "BIta" wrote in message | ups.com... || 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 || | | |
|
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Setting EnableResize = False
Thanks Jim a lot. I found another way too:
Application.ActiveWorkbook.Protect Structu=True, Winodws:=True Cheers, --Bita |
| 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) | |||
| 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 | |||
Linear Mode
