Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Objects not showing up in VBA properties
Hi: Can anyone please tell me how to make all of the objects in a workbook show up in the VBA's property window? I have a command button on a sheet that executes the VBA commands as it should. I can view the commands so I know its there. For some reason it does not show up in the VBA properties box. I also believe that There is a user form that is not showing up as well. Is there a way to get them to show up? Thank you for any suggestions! ------------------------------------------------ ~~ Message posted from http://www.ExcelTip.com/ ~~View and post usenet messages directly from http://www.ExcelForum.com/ ~~Now Available: Financial Statements.xls, a step by step guide to creating financial statements |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Objects not showing up in VBA properties
Aet-inc wrote:
Can anyone please tell me how to make all of the objects in a workbook show up in the VBA's property window? I have a command button on a sheet that executes the VBA commands as it should. If the button is from the Forms toolbar (not the Control Toolbox) then it will not show up in the VBA properties window. Instead, Right-click / Format Control. I also believe that There is a user form that is not showing up as well. It may be an Excel 5 dialogsheet. You access it through Excel. It would appear as a sheet tab alongside the worksheets. It might be hidden (Format / Sheet / Unhide) or very hidden (only unhideable by VBA code: ThisWorkbook.Sheets("TheDialogName").Visible = True Bill Manville MVP - Microsoft Excel, Oxford, England No email replies please - reply in newsgroup |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Automatically showing the document's properties when it is opened | Excel Discussion (Misc queries) | |||
using the address properties from range objects in a sum formula | Excel Discussion (Misc queries) | |||
Showing Custom file properties in Header | Excel Discussion (Misc queries) | |||
Beginer to UserForms question on assigning properties to objects | Excel Discussion (Misc queries) | |||
remove read only - not showing up in properties | Excel Worksheet Functions |