Properties - Workbook and Worksheet

S

Sandy

Hello!

Does anyone know where I can get a list of all properties
and what they are for at both the workbook and worksheet
levels?

There are some properties that when I try searching Help,
are simply not listed by the property name that is in the
workbook/worksheet.

Sandy
 
R

Rob Bovey

Hi Sandy,

The best place to find this list is in the Object Browser. Press F2
inside the Visual Basic Editor to bring it up. Locate and select the object
you're interested in on the left side of the Object Browser and all of its
properties, methods, and events will be listed on the right. Select any of
these and press F1 to bring up the help file topic for the selected item.

--
Rob Bovey, MCSE, MCSD, Excel MVP
Application Professionals
http://www.appspro.com/

* Please post all replies to this newsgroup *
* I delete all unsolicited e-mail responses *
 

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

Turning off automatic calculation 0
How to assign a worksheet in VBA 3
Custom Document Properties in Word documents and Excel workbooks 15
Auto Calculate selected worksheets 5
Place picture in Excel cell 0
Custom Properties for Worksheets and Workbook 0
Excel Property is showing as Book not Workbook 0
Shared Workbooks & Code 1

Top