commandBar reset

[bstubbs]

Howdy again, folks:

I have a spreadsheet with 5 sheets. On all of the sheets except the first one, I want the right-click to function as normal. On that first sheet ("Absentee Daily Log"), I want all cells to just "beep" on right click unless the active cell is non-blank and within Column B, when I want to present a custom menu of options. On that first sheet, everything is operating ok. On the other sheets, however, I continue to get my custom menu, where I only wanted to use that on the first page. Clear?

Here's the germane code:

Please Login or Register  to view this content.

Can anyone tell me why the custom menu is showing on all of the other sheets?

TIA, guys.

Bob

[Shijesh Kumar]

this is one of the approach to run marco only the specified workbook

Please Login or Register  to view this content.

[bstubbs]

bump - still need assistance.

TIA.

Bob

[Paul]

Hi Bob,

Put your code in the Worksheet_Activate and Worksheet_Deactivate events for the Absentee sheet. When that sheet becomes active the code should run to create the custom menu, and when another sheet becomes active the code should return the menu to normal.

Hope that helps.