Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Enable Command Bar
I am using Excel 2003 and created a Pivot report to be used by multiple
users. Periodically, the data needs to be refreshed. The 'Pivot Table' command bar was not loading when other users opened the file, so I added the following in the WB code: Private Sub Workbook_Open() Application.CommandBars("PivotTable").Visible = True End Sub The command bar now loads, however, is greyed out for the other users. What can be added to this sub-routine to enable this command bar? Any suggestions greatly appreciated. -- Linda |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Enable Command Bar
Application.CommandBars("PivotTable").Visible = True
Application.CommandBars("PivotTable").Enabled = True "mathel" wrote: I am using Excel 2003 and created a Pivot report to be used by multiple users. Periodically, the data needs to be refreshed. The 'Pivot Table' command bar was not loading when other users opened the file, so I added the following in the WB code: Private Sub Workbook_Open() Application.CommandBars("PivotTable").Visible = True End Sub The command bar now loads, however, is greyed out for the other users. What can be added to this sub-routine to enable this command bar? Any suggestions greatly appreciated. -- Linda |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Enable Command Bar
Hi Atishoo,
I copied the line and added it to my WB code, saved the file and had another user open it - the Command Bar remains greyed out. Any other thoughts? I don't understand why the Pivot Command bar is OK on my document, but no one elses! -- Linda "Atishoo" wrote: Application.CommandBars("PivotTable").Visible = True Application.CommandBars("PivotTable").Enabled = True "mathel" wrote: I am using Excel 2003 and created a Pivot report to be used by multiple users. Periodically, the data needs to be refreshed. The 'Pivot Table' command bar was not loading when other users opened the file, so I added the following in the WB code: Private Sub Workbook_Open() Application.CommandBars("PivotTable").Visible = True End Sub The command bar now loads, however, is greyed out for the other users. What can be added to this sub-routine to enable this command bar? Any suggestions greatly appreciated. -- Linda |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Enable Command Bar
try Tools, Share Workbook..., allow multiple users. (check and de check this option try both ways) try turning off sheet protection. if i get any more ideas ill let you know |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Enable Command Button Procedure | Excel Discussion (Misc queries) | |||
Enable/Disable Command Button | Excel Programming | |||
Urgent: Enable All of the excel command bar | Excel Programming | |||
enable menu command not working | Excel Programming | |||
Enable Command Button 1 & 2 | Excel Programming |