Saving hidden data with a worksheet (preferably without using a hidden sheet)

  • Thread starter Thread starter Aaron Queenan
  • Start date Start date
A

Aaron Queenan

I want to save some data with the worksheet from within the Worksheet_OnSave
event handler. Is there any way to do this without adding an extra sheet to
the workbook?

The Excel4 API had a xlDefineBinaryName function. Is there any way to call
it using COM, via my own Excel4 function if necessary?

Thanks,
Aaron Queenan.
 
Aaron

What is the nature of the data you want to save?

There is no need to post to all those groups.
 
Just formatting information, but it isn't something that I want to be
accessible to the users, even by using the VBA editor. The only way I have
heard of doing that is using the xlDefineBinaryName function. I would like
to call it in the WorkSheet_Open or WorkSheet_Close event, but I'm not sure
how to call it from COM.

Thanks,
Aaron.
 
Back
Top