CODEWITHSUNDEEP
vbaexceltoggle
Mike
Mike

Reputation: 4405

Click to toggle sheet tab

I am trying to use VBA to create the same action you would do if you had an Excel spreadsheet open with 3 sheet and you want to toggle between sheets exactly like when you click on the sheet tab at the bottom of the workbook (i.e. Toggle between Sheet1, Sheet2, Sheet3 by clicking on the sheet tabs)

I've tried some thing:

book.Worksheets(1).Activate = True

book.Worksheets(1).Activate

sheet.Visible = True

But nothing seems to work. I'm not sure Activate is what I want. I think that just makes the sheet active, but not visible. Visible seems to do nothing. How can this be accomplished?

Upvotes: 0

Views: 877

Answers (2)

Mike
Mike

Reputation: 4405

thanks for the feedback. I have been attempting to use com objects in python. they usually interop with each other quite well, but this is one thing that doesn't seem to work. I've tried all of your suggestions with no results.

I managed to find a workaround by just moving the sheets around using: 

sheet.Move(Before=book.Worksheets(1))

For some reason, when the sheet is moved, it also activates it which is my desired end result. It works for the scenario I am scripting, but may not for other people trying to do something similar.

Upvotes: 0

chancea
chancea

Reputation: 5958

book.Worksheets(1).Activate

Is designed to perform the action you want "clicking on a tab"

You can also try

book.Worksheets(1).Select

Which can be used to select multiple tabs (see Have a look at What is the difference between Sheets.Select and Sheets.Activate?)

I am guessing something is not right either with your workbook reference or something else in your code. If you make a new excel file and just try Sheets("Sheet2").Activate it will select that tab.

Upvotes: 1

Related Questions