Getsetting and Savesettings
 

Hello,
Does anyone have any experience with Getsetting and Savesetting ?
I've put a check box on a splash screen that the user can check so the
splash screen wont' appear anymore.
However, it's not working right.
When the user checks the box the setting is saved and it will work next
time, but the next time the workbook opens the splash screen doesn't appear
so the routines thinks the box is unchecked so show the splash screen the
third time the workbook is opened, and on it goes like this.
I'm using the Getsetting in the workbook open sequence, but saving the
setting in the screen closing, I sure this is not correct but I don't know
how to make it work the right way.
If any one knows of a tutorial on Getsetting or Savesetting I would
appreciate that also.
Thanks
James

Getsetting and Savesettings
 

Hi James

See John's site for information
http://j-walk.com/ss/excel/tips/tip60.htm


--
Regards Ron de Bruin
http://www.rondebruin.nl


"James" wrote in message ...
Hello,
Does anyone have any experience with Getsetting and Savesetting ?
I've put a check box on a splash screen that the user can check so the splash screen wont' appear anymore.
However, it's not working right.
When the user checks the box the setting is saved and it will work next time, but the next time the workbook opens the splash
screen doesn't appear so the routines thinks the box is unchecked so show the splash screen the third time the workbook is opened,
and on it goes like this.
I'm using the Getsetting in the workbook open sequence, but saving the setting in the screen closing, I sure this is not correct
but I don't know how to make it work the right way.
If any one knows of a tutorial on Getsetting or Savesetting I would appreciate that also.
Thanks
James

Getsetting and Savesettings
 

Thanks,
I should have thought about j-walk.com first, he has some reallyu good stuff
james
"Ron de Bruin" wrote in message
...
Hi James

See John's site for information
http://j-walk.com/ss/excel/tips/tip60.htm


--
Regards Ron de Bruin
http://www.rondebruin.nl


"James" wrote in message
...
Hello,
Does anyone have any experience with Getsetting and Savesetting ?
I've put a check box on a splash screen that the user can check so the
splash screen wont' appear anymore.
However, it's not working right.
When the user checks the box the setting is saved and it will work next
time, but the next time the workbook opens the splash screen doesn't
appear so the routines thinks the box is unchecked so show the splash
screen the third time the workbook is opened, and on it goes like this.
I'm using the Getsetting in the workbook open sequence, but saving the
setting in the screen closing, I sure this is not correct but I don't
know how to make it work the right way.
If any one knows of a tutorial on Getsetting or Savesetting I would
appreciate that also.
Thanks
James