-
John,
I only changed your code to A1000 because I was planning to put the prompt on another page and typo'd the A100.
Your code works except for canceling the save prompt,
it still hides the sheets, so I have to close and re-open to unhide the sheets.
can we move the save prompt to hide the sheets only if save not canceled?
or store the answer to the save query than hide if yes and save,
cancel hide and not save and not close if cancel,
if no then just close without saving..
Looking at XLD's note to close and re-open might be the trick.
This is going passed my skill level for coding though.
Mark
-
How do I have this not unhide "menuSheet"
[vba] For Each Sheet In Sheets
If Not Sheet.Name = "Prompt" Then ' ="Prompt" AND "menuSheet" then?
Sheet.Visible = xlSheetVisible
End If
Next
[/vba] I'm working to get the saving issues fixed but I added a menu
that uses a sheet to pull values from...
I don't want the sheet invovled visible. "menuSheet"
this workbook open script fires to unhide sheets if macros are enabled.
on close we hide everything but the prompt that will be visible ony if macros are disabled on the next open.
I don't wan't this menusheet visible..
Thanks for your help.
Mark
-
You can use:
[vba]If Not (Sheet.Name = "Prompt" Or Sheet.Name = "menuSheet") Then[/vba]
-
Thanks rory,
that works great
Mark
sorry about the food network show going to amy...
-
working sample
To All,
Here is the file I have been working on so far.
It prompts for macros to be enabled before unhiding the working sheets.
It has a menu list in the Add-ins folder in excel 2007 (LinkUs WPR Actions)
or its own menu in previous versions (thanks to JWalk)
The purpose of the project is to allow our offices to have a streamlined way of pulling from a web data base and manipulate the info into a form to preform a quality check on jobs.
The field work gets entered into the form and repopulates for electronic and/or paper archives.
It also pulls together detail info about the data results as an office group
or by the individual level in 2 pie charts.
99% of the coding came from this forum.
I've looked at a few other forums,
but none have the depth of results as this one.
Commenting code helps tons to know how it works...
I only new what VBA stood for when I came here.
Now I have an idea of what it can do.
I used to post questions with "can VBA do something",
now I start with "how do we do it"
If VBA and this forum can't do it, does it need to be done?
Thanks so much to everyone.
Mark
attachment is from excel 2007 in 97-2003 compatible mode
- lots of macros :cloud9:
