View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Bob Phillips[_6_] Bob Phillips[_6_] is offline
external usenet poster
 
Posts: 11,272
Default Storing values to arrays for subsequent use

I presume that you mean the visible property? Just store it in an array.

--

HTH

RP
(remove nothere from the email address if mailing direct)


"Peter Rooney" wrote in message
...
Don Lloyd (ably assisted by Toppers) provided me with an excellent

solution
for my hiding visible toolbars on opening/redisplaying them again when
closing issue earlier today.
However, I'm still intrigued by the possibility of storing a value to a
variable or an array, then having those values preserved for use later on.
Of course, one way to do this is to store the values in a dummy worksheet,
but I've always thought this to be a bit untidy.
Does anyone have any observations on the best way to do this, if indeed

it's
possible?

Thanks in advance

Pete