0
How do you lock a Microsoft Excel workbook to always open on the same worksheet and cell instead of on whichever worksheet or cell you were on when you last saved the file?
Wiki User
∙ 11y ago
Private Sub Workbook_Open()
Worksheets(1).Activate
End Sub
In VB worksheet
Wiki User
∙ 11y ago
Add your answer:
Earn +20 pts
Is it TRUE that Excel opens with a new blank workbook displayed?
Yes, when you start Excel in the normal way, you will be presented with a blank workbook. However, you can choose an Excel file from your folders before opening Excel, and if you double click on it, it will start Excel and have that file open when it starts, instead of a blank workbook.
How can you separate the worksheets within a workbook into their own files in excel?
There is no automatic method to save each worsheet as a separate file, you need to do that manually. If you have three worksheets, then save the file two more times, so you have three worksheets instead of only one. Open each workbook and delete the worsheets you do not want in that file. Repeat the process until you have only one worksheet in each workbook.
Where can I find Microsoft Excel training?
Training Overview Charts make data visual . Instead of having to analyze columns of worksheet numbers, you can see at a glance what the data means........
How do you get out of compadibility mode in Excel?
Save the workbook as an Excel 2007 file instead of 97-2003 file.
What is different software that can be used instead of Microsoft office?
Open Office and Microsoft Works.
Does the app store have Microsoft office?
No, you can get iWork instead which lets you convert things you create into Microsoft Office documents.
Can Microsoft Windows Explorer be used instead of the NetWare Map command?
no why
In Microsoft Excel what is the meaning of Numeric?
number instead of a letter (text)
For users of the discontinued Microsoft Office Live Meeting what is recommended for them to use instead?
One can use programs like GoToMeeting and Netviewer instead of Microsoft Office Live Meeting. These programs offer the same features as Microsoft Office Live Meeting, but are much more popular.
What are the uses of Microsoft Genuine?
The Windows Genuine Advantage is the phrase used by Microsoft to describe the benefits of using real Microsoft products instead of counterfeits. These advantages include automatic updates and security notices.
Where can you get 2007 Microsoft Office for free?
You can get the Microsoft Office suite at Microsoft Store website, but unfortunately you cannot find Office 2007 or any older versions available on the Microsoft's store website currently. But instead you can get a copy of Microsoft Office 365 or 2013. You can evaluate it for a period of 30 days and also extend the trial.
What is a spreadsheet is often called?
It can be called a worksheet. There is a range of actual spreadsheet programs, so people often refer to them directly, like Excel or Quattro or Works or Open Office or Lotus 123, instead of using the term spreadsheet.
