My boss just gave me a Summary Rollup spreadsheet with a whole bunch of tabs. One of those tabs contains a small chart.When i right click on the chart to get the source data, it give me location of a tab that does not appear to be in view. My question is that are the tabs hidden for the source data of this chart so that I cannot see it? If so how can I get access to it. I need to change a few numbers in the chart.
Hi,
Right click on the tabs.
Go to View code.
Press F4 to bring up the properties window.
Select the appropriate sheet in the project window.
Change the visible parameter in the properties window to 1 - xlsheetvisible
Sarcasm - because beating the **** out of someone is illegal.
Worked like magic
Thanks a million Sweep. It worked like magic. I really appreciate it. Made me look good with the bossman.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Reply With Quote
Bookmarks