permanently storing values

epymsam · Apr 5th, 2002, 03:45 AM

Hi,

I want to permanently store a value that can be referenced next time the sheet is opened, but I'd prefer not to use the sheets to store the value as these can then be edited by the user.

What I want to do is store the value as a permanent constant.

Something similar to the word VBA stuff:
activedocument.Variables.Add "sample", 19

Any ideas anyone,

Any help much appreciated.

Cheers,

epymsam

Jay Petrulis · Apr 5th, 2002, 07:05 AM

Hi,

Insert>Name>Define

Name your variable and assign it the value you want.

This isn't foolproof, but should be OK.

You also may want to assign a constant in a VBA module and password protect the VBA so the variable can't be changed. I don't know off hand what would happen if someone tries to reassign the value of the variable by naming it, for instance.

HTH,
Jay

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Apr 5th, 2002, 03:45 AM	#1
epymsam New Member Join Date: Mar 2002 Posts: 2	Hi, I want to permanently store a value that can be referenced next time the sheet is opened, but I'd prefer not to use the sheets to store the value as these can then be edited by the user. What I want to do is store the value as a permanent constant. Something similar to the word VBA stuff: activedocument.Variables.Add "sample", 19 Any ideas anyone, Any help much appreciated. Cheers, epymsam

Apr 5th, 2002, 07:05 AM	#2
Jay Petrulis MrExcel MVP Join Date: Mar 2002 Location: Chicago, IL USA Posts: 2,042	Hi, Insert>Name>Define Name your variable and assign it the value you want. This isn't foolproof, but should be OK. You also may want to assign a constant in a VBA module and password protect the VBA so the variable can't be changed. I don't know off hand what would happen if someone tries to reassign the value of the variable by naming it, for instance. HTH, Jay