Storring global data in Excel

  • Thread starter Thread starter Roger Whitehead
  • Start date Start date
R

Roger Whitehead

I often use XLVeryHidden worksheets:
ViewCode from a sheet tab. In the Visible Property, select XLVeryHidden. The
sheet can now only be made visible with VBA, or manually from within the
VBE.
 
Mark,

There are a variety of ways. One way is to store data in defined
names. Another is to store data in a hidden worksheet. Yet
another way is to save data in the system registry. It depends
on the type and quantity of data you need to save.


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com
 
Hi NG

What is the prefered way to store global data in a VB application?

I sometimes run into trouble, when attempting to store global data, when
a module is unloaded or a sheet is deleted.

Regards
Mark
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Problem with ".Visible" sheet property 2
Preventing "Protect Workbook" 2
How to check if an Add In is present. 7
Modify data on a hidden sheet? 5
Sheets - xlVeryHidden 2
Case select and sheet codename 7
Workbook open code to do 2 things 1
Open/Close Event and Excel Saving process 2

Back
Top