autosave add-in settings

D

Daniel

Good morning,

I changed the settings of the autosave add-in (do not prompt before save etc)
but whenever i close excel and load it again it always reset the settings to default values. Is there a way to retain my settings as the new default values? Or is the some coding I can use to automatically reset the values instead of manually having to do it.

Thank you

Daniel
 
K

keepITcool

Daniel,

I'm not sure if following will work for the autosave addin
but i'd give it a try...

double click the autosave project in vbe.

Use following hint to answer the prompt:
What name do South Africans use for CONNOCHAETES TAURINUS?

(1st letter uppercase, add 2 exclamation marks)

somewhat surprising in relation to their views on public licensing..

cryptic? sure! <VBG>


keepITcool

< email : keepitcool chello nl (with @ and .) >
< homepage: http://members.chello.nl/keepitcool >
 
K

keepITcool

I had to install it to be able to check..


you can do it much simpler...

In Excel:
select the settings you want.

Open the VBEditor
make sure Project window and immediate window are visible.

In the Project Explorer select Autosave.xla
In the Immediate Pane type thisworkbook.s

Done.



The hard way would be (and for your curiosity ?)

thisworkbook.isaddin = false
now goto sheet 'LocTable'
the settings are stored in range K8:15

k8 named [ud01n.Do_Save] is a boolean Save/DontSave
k10 named [ud01n.Frequency1] is the frequency in minutes
k12 named [ud01n.Save.Option is 1 for active workbook
is 2 for all workbooks
k15 named [ud01b.Prompt] is a boolean Prompt/NoPrompt


before saving make sure you set
thisworkbook.isaddin to TRUE


keepITcool

< email : keepitcool chello nl (with @ and .) >
< homepage: http://members.chello.nl/keepitcool >
 
D

Daniel

Sorry to bother you again, but I've tried what you suggested and it just doesn't seem to work (for me at least). I set the settings the way I want them. then I select the Autosave.xla and in the immediate window entered thisworkbook.save and pressed enter.

am I missing something?

could you run through it one more time.

Thank you for the help.

Daniel
 
Top