Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
determining a Commndbar name from a cell
This macro is supposed to show a particular Commandbar by getting the
name, previously saved, from cell "E2" in the named spreadsheet. I'm getting an "invalid use of property" error on the marked line. I've tried about 6 different ways of coding this, but none of them have worked. Private Sub Workbook_Activate() Dim strTBarName As String strTBarName = Workbooks("PIP DD Template HideTbar.xls") _ .Worksheets("Macro Records").Range("E2").Value Set cTBar.Name = strTBarName <---ERROR cTBar.Visible = True So I can't set the object's name, only the object. How do I make the object be the one named in the referenced cell ("E2")? Thanks for the help. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Determining a previous cell value if deleted | Excel Programming | |||
Determining A Cell If it contain A string value | Excel Programming | |||
Determining text in a cell | Excel Programming | |||
Determining active conditional format of one cell | Excel Programming | |||
Determining whether selected cell has value or formula? | Excel Programming |