-
That code is the old code, it has been revised to also cater for chart sheets, the revision's here... Pls don't change anything, just copy and paste it, the code's self-contained and ready to go as it is so there was absolutely no point changing A100 to A1000. The only thing that should be on the prompt sheet is a message to enable macros and the only thing that may possibly need changing is the name of the "Prompt" sheet (i.e. if you don't like the name "Prompt" and want to name it as something else) 
PS if you do need to change things such as addresses, don't rely on your eye finding all instances, use the "find and replace" tool in the VBE window to be thorough about it.
EDIT: Oh, and by the way, the line you've just added (copied below) is so totally unnecessary, if it's not saved Excel will automatically ask if you want to save...
[VBA]
ElseIf ActiveWorkbook.Saved = False Then MsgBox "Save changes? vbyesnocancel"
[/VBA]
You know you're really in trouble when the light at the end of the tunnel turns out to be the headlight of a train hurtling towards you 
The major part of getting the right answer lies in asking the right question...
Made your code more readable, use VBA tags (this automatically inserts [vba] at the start of your code, and [/vba ] at the end of your code) | Help those helping you by marking your thread solved when it is.
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
Reply With Quote