how to exit macro if workbook saved

**sspreyer** · 10-25-2013, 01:55 PM

hi to all you excel gods
i have some code that makes a range of cells flash but would like it stop flashing if the workbook is saved "exit the Macro" i have tried numerous whys of try to get this to work with no joy i know i need something like thisworkbook.save then exit sub this doesnt work here my code

Please Login or Register  to view this content.

thanks in advance

shane

**Solus Rankin** · 10-25-2013, 02:03 PM

You could try using a cheater cell. The cell can be any cell you don't use and can hide.

Please Login or Register  to view this content.

with

Please Login or Register  to view this content.

**sspreyer** · 10-25-2013, 02:10 PM

hi thanks where do i put this part of the code :

Please Login or Register  to view this content.

cheers
shane

**sspreyer** · 10-25-2013, 02:11 PM

Originally Posted by sspreyer

hi thanks where do i put this part of the code :

Please Login or Register  to view this content.

cheers
shane

me being a bit slow worked out sorry

thanks

**sspreyer** · 10-25-2013, 02:15 PM

hi
im getting subscript out of range "9" here my code

Please Login or Register  to view this content.

and

Please Login or Register  to view this content.

**sspreyer** · 10-25-2013, 02:20 PM

hi
right i got the code to work with no errors but still does not stop the cells from flashing when saving i found it actually restarts the macro

cheers

shane

**Solus Rankin** · 10-25-2013, 02:30 PM

You have several loops going there. I keep losing track

Try putting

Please Login or Register  to view this content.

on the final loop

e/

Please Login or Register  to view this content.

**sspreyer** · 10-25-2013, 02:42 PM

hi
still not working when i save the work book it retriggers the macro and cell starts flashing to make it abit easier i have attached workbook to show
Cmm Tracker test.xlsm

cheers

shane

**Solus Rankin** · 10-25-2013, 03:16 PM

Thats because you're calling the flashback sub in the worksheet change event. Its going to start flashing every time you change anything.

e/ You can disable events using the aftersave event, but none of your event triggered macros will work again until you enable events.

how to exit macro if workbook saved

LinkBack

Thread Tools

Rate This Thread

Display

how to exit macro if workbook saved

Re: how to exit macro if workbook saved

Re: how to exit macro if workbook saved

Re: how to exit macro if workbook saved

Re: how to exit macro if workbook saved

Re: how to exit macro if workbook saved

Re: how to exit macro if workbook saved

Re: how to exit macro if workbook saved

Re: how to exit macro if workbook saved

Thread Information

Users Browsing this Thread

Similar Threads

Macro to exit all workbook leaving one specific workbook open

[SOLVED] Run macro on exit worksheet/workbook

[SOLVED] Run macro on exit worksheet/workbook

Run macro on exit worksheet/workbook

[SOLVED] Run macro on exit worksheet/workbook

Bookmarks

Bookmarks

Posting Permissions