Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
I have a form button placed on a sheet. It is assigned to a fully
qualified macro name, as in wb.xlsm!sheet.addRows. Concerning the Application.ActiveSheet method. Can I be sure that an early call to Application.ActiveSheet in the macro returns the sheet upon which the button resides? Seem to be true, but I've read, somewhere, that the active sheet may change at any time and this really isn't to be depended on. How can I insure that the sheet I retrieve is the sheet where the button resides? #2 AND, if it can not be relied on, should you ever use it? |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Application.Volatile False doesn't work with Application.Run? | Excel Programming | |||
Use a password in VBA ActiveSheet.protect & ActiveSheet.unprotect? | Excel Programming | |||
Copying new activesheet after other activesheet is hidden? | Excel Programming | |||
Replace application.RTD property by Application.RTDServers collect | Excel Programming | |||
macro to close excel application other than application.quit | Excel Programming |