LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 16
Default Storing flag values at worksheet level (Property or Properties)

In a workbook with a number of worksheets, I have some VBA code that copies
certain worksheets (and then hides the old versions of those that were
copied). I've been playing around with different methods of designating
which worksheets should be copied. It would be helpful if I could simply
attach a boolean flag at the worksheet level to all the worksheets,
designating which are to be copied and which aren't. I also have a second
such need for associating a flag at the worksheet level.

Would it make sense to use a Public Property or a new user-defined member of
the Properties collection? If so, can somoene point me to a good example?
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
HOW CAN I FLAG A CELL IN EXCEL WHEN IT HITS A REORDER LEVEL? PENNY Excel Worksheet Functions 2 July 11th 08 01:56 PM
difference of worksheet name and (name) property in VBA properties [email protected] Excel Programming 2 July 28th 06 12:32 AM
Storing variable values in Excel worksheet Henry Stockbridge Excel Programming 3 April 25th 06 02:38 PM
Print>Properties>Layout>Pages per sheet: this function/property . Turck Excel Discussion (Misc queries) 2 May 28th 05 10:45 PM
Storing various data in .ID property Thorsten Walenzyk Excel Programming 10 December 9th 04 08:27 PM


All times are GMT +1. The time now is 02:02 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"