Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Checking before opening "activate:newwindow" to see if already opened
When a macro button (name = ON") is pressed, I want to open a new window, if
not already opened, with a wildcard extension of "*:2" and then close if if this macro button is pressed (name = Off). Currently, when I press ON, it just keeps opening a new window and gives extensions ":2", ":3", ":4", etc. Thank you for your help -- Message posted via http://www.officekb.com |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Checking before opening "activate:newwindow" to see if already opened
Post the offensive code. It is easier/more useful to you to edit your
existing code than to hypothesize a lot of information and write a new macro. I assume this new window is relative to the current workbook. What kind of button - commandbar button? -- Regards, Tom Ogilvy "sam s via OfficeKB.com" wrote in message ... When a macro button (name = ON") is pressed, I want to open a new window, if not already opened, with a wildcard extension of "*:2" and then close if if this macro button is pressed (name = Off). Currently, when I press ON, it just keeps opening a new window and gives extensions ":2", ":3", ":4", etc. Thank you for your help -- Message posted via http://www.officekb.com |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Checking before opening "activate:newwindow" to see if already opened
Tom Ogilvy wrote:
Post the offensive code. It is easier/more useful to you to edit your existing code than to hypothesize a lot of information and write a new macro. I assume this new window is relative to the current workbook. What kind of button - commandbar button? When a macro button (name = ON") is pressed, I want to open a new window, if not already opened, with a wildcard extension of "*:2" and then close if if this macro button is pressed (name = Off). Currently, when I press ON, it just keeps opening a new window and gives extensions ":2", ":3", ":4", etc. Thank you for your help By the way, I meant to say MSG boxes , not dialog boxes in my other explanation. Thanks -- Message posted via http://www.officekb.com |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to Activate "Show all" in a Protected Shared Workbook | Excel Discussion (Misc queries) | |||
Excel - Golf - how to display "-2" as "2 Under" or "4"as "+4" or "4 Over" in a calculation cell | Excel Discussion (Misc queries) | |||
Excel files suddenly "read only" or encrypted and cannot be opened | Excel Discussion (Misc queries) | |||
Shortcut key for "Paste Options" and "Error Checking" buttons? | Excel Discussion (Misc queries) | |||
selection.find shortening the procedure by skipping the "activate" part | Excel Programming |