Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
How do I change and address/access the "(Name)" property of a sheet with VBA;
this property is only 'visible' in the VBA properties window, it is not visible in the object browser? This property is not the same as "Name" which is also shown on the tab. My code creates sheets during a simulation. Currently the user can delete the programatically created sheets, but this will also delete any user created sheets. I want to use the "(Name)" property to control which sheets are deleted. Pseudo code.... if sheet.name < "KeepThisSheet0" And sheet.name < "KeepThisSheet1" then sheet.delete Also, what are the differences between the objects "Sheets" and "Worksheets" Windows XP, Excel 2007 Thank you all very much! |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
automatically appending newly added data on worksheet to a master list worksheet | Links and Linking in Excel | |||
plot graph from multiple worksheet as embedded chart object on every worksheet | Charts and Charting in Excel | |||
plot graph from multiple worksheet as embedded chart object on every worksheet | Excel Discussion (Misc queries) | |||
Upload multiple text files into 1 excel worksheet + put the filename as the first column in the worksheet | Excel Worksheet Functions | |||
Attaching a JET database to an Excel Worksheet OR storing large binary data in a worksheet | Excel Programming |