INTERACT FORUM
More => Music, Movies, Politics, and Other Cheap Thrills => Topic started by: marko on September 03, 2011, 06:39:22 am
-
I was wondering if it's possible to create an excel file that, no matter which tab is active when last saved, always opens with the first tab on view, without using macros?
I would then like to have that first tab have named links that switch to other tabs in the workbook when clicked...
Is this achievable?
-
I don't think so.
more so, not without using macros
is there a reason you don't want to use macros?
-
Macros are out because the file would contain reports for a dozen or so individuals, and many of the recipient's pcs are locked down tighter than a tight thing and won't allow macros to run. At the moment all the reports are individual files, and I want to try and ease the reporting process by merging them into a single file. I will need to sell the idea to the individual recipients first though, so the slicker I can get it, the better my chances...
I know excel has a lot of power, but I don't know much about it, or its limitations.
thanks for replying btw, it's appreciated.
-
I don't know if this helps, but it is something I found on the subject.
===============
To open to a specific sheet (in case it's not the last one used) you would need a Worksheet Open Event - using VBA.
From Excel, press Alt+F11 to open the VB Editor. Look for the name of your workbook in the left pane. Click on the + sign to expand the view and double click on ThisWorkbook. In the right pane there are two dropdowns at the top. Click on the left one and choose 'Workbook'. Now copy and paste this code to the right pane
Code:
Private Sub Workbook_Open()
Worksheets("Example").Activate
End Sub
Change the sheet name (in speech marks above) to match the one you need.
Now when the workbook opens, it will open to your desired sheet.
-
I don't know if this helps, but it is something I found on the subject.
===============
To open to a specific sheet (in case it's not the last one used) you would need a Worksheet Open Event - using VBA.
From Excel, press Alt+F11 to open the VB Editor. Look for the name of your workbook in the left pane. Click on the + sign to expand the view and double click on ThisWorkbook. In the right pane there are two dropdowns at the top. Click on the left one and choose 'Workbook'. Now copy and paste this code to the right pane
Code:
Private Sub Workbook_Open()
Worksheets("Example").Activate
End Sub
Change the sheet name (in speech marks above) to match the one you need.
Now when the workbook opens, it will open to your desired sheet.
I Just Tested That, That actually works, Cute
-
Hopefully this solves marko's issue.
Excel does a lot, but it's hard to figure out how to do things with it.
-
Yep, I learned some of excel by taking others and modifying some of the code to do what I needed. I had a boss once that showed me how to do some things when playing with inventories, and employee production.
-
I don't know if this helps, but it is something I found on the subject.
===============
To open to a specific sheet (in case it's not the last one used) you would need a Worksheet Open Event - using VBA.
From Excel, press Alt+F11 to open the VB Editor. Look for the name of your workbook in the left pane. Click on the + sign to expand the view and double click on ThisWorkbook. In the right pane there are two dropdowns at the top. Click on the left one and choose 'Workbook'. Now copy and paste this code to the right pane
Code:
Private Sub Workbook_Open()
Worksheets("Example").Activate
End Sub
Change the sheet name (in speech marks above) to match the one you need.
Now when the workbook opens, it will open to your desired sheet.
I found this as well, but the thread I read said you need Macros enabled to be able to use it...
-
I found this as well, but the thread I read said you need Macros enabled to be able to use it...
I think your right, I just adjusted security to high, and that disables macros, and does not allow the sheet1 to be selected after a save on sheet2.
-
Still, something to be going on with, thanks for the replies.
I've knocked up a draft file and will try it out with a few recipients on Monday to see how it behaves. "Hyperlink" was the answer to worksheet links on the first sheet. They seem to work OK, and automatically update when a "Save As.." gives the file a new name, which is nice.
I'll let you know how I get on....
-
I don't know if this helps, but it is something I found on the subject.
===============
To open to a specific sheet (in case it's not the last one used) you would need a Worksheet Open Event - using VBA.
From Excel, press Alt+F11 to open the VB Editor. Look for the name of your workbook in the left pane. Click on the + sign to expand the view and double click on ThisWorkbook. In the right pane there are two dropdowns at the top. Click on the left one and choose 'Workbook'. Now copy and paste this code to the right pane
Code:
Private Sub Workbook_Open()
Worksheets("Example").Activate
End Sub
Change the sheet name (in speech marks above) to match the one you need.
Now when the workbook opens, it will open to your desired sheet.
This appears to work. The PCs I tested on threw a warning on file open, where a press on the OK button allows the file to open and switch to the first worksheet. That'll do for me, hopefully I've sold the idea well enough... Thanks again.
-
Great...
-
This appears to work. The PCs I tested on threw a warning on file open, where a press on the OK button allows the file to open and switch to the first worksheet.
That's what I got.