Hi, thanks to those that have helped so far! I have many worksheets in a workbook that need to be saved if a user changesanything on them.
These sheet names all end in "....SD" and the code needs to only run on those sheets. I have learned alot from the forum but not enough, just yet . . This is what I have so far:
It doesn't like the 2 "Then's". (Don't laugh - I'm trying.)HTML Code:Thank you!!
Last edited by pprseller; 10-29-2009 at 02:13 PM.
Maybe just this?
Please Login or Register to view this content.
Entia non sunt multiplicanda sine necessitate
That works but its prompting after every cell is typed in. Maybe I'm using the wrong worksheet/workbook event. Can you suggest what to use? The scenario is that I have worksheets that are used over and over again and not saved. The worksheets that end in "SD" must be saved after a change. So the workbook close event won't work either. Is there a way to prompt save when a sheet "loses focus"? Thanks . . . .
The code I posted doesn't prompt at all, does it? It just saves worsheeets ending in "sd" after any manual change.
I have code for "before save" prompting user if they are sure they want to save. So I took that out and your code works fine except on every cell change the workbook saves and it takes about 15 seconds to save each time (it's a large workbook!). How can I stop that? (This a worksheet where the user will be filling in 15 fields so that will be too long to wait it out each time a cell is changed.)
So ... what behavior do you want?
I want the worksheet to be saved when the user is done using it - all the way done, not cell by cell.
If "done" means when the sheet is deactivated, then
Please Login or Register to view this content.
Thanks, that will do it. I appreciate your help.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks