Hello:
This is likely to be a very simple question to answer but I have searched through the BM Manual and, for the life of me, I cannot find out how to set the active sheet (or change it) once I have opened a spreadsheet file with multiple sheets.
Your assistance is much appreciated!
Sparky
How to Set the Active Sheet
-
- Posts: 14
- Joined: Fri Jun 20, 2014 3:25 pm
Re: How to Set the Active Sheet
Yes, please check the below code, which will open sheet number 4:
Instead of passing sheet number, you can also pass sheet's name like this:
Code: Select all
sub main
' PlanMaker starten
Set pm = CreateObject("PlanMaker.Application")
pm.Visible = True
pm.Activate
pm.activeWorkbook.Sheets(4).activate
end sub
Code: Select all
pm.activeWorkbook.Sheets("test").activate
Post Reply
2 posts
• Page 1 of 1
Return to “BasicMaker 2021 for Windows”
Jump to
- SoftMaker Office NX and 2024
- ↳ SoftMaker Office NX and 2024 for Windows
- ↳ SoftMaker Office NX and 2024 for Windows (General)
- ↳ TextMaker NX and 2024 for Windows
- ↳ PlanMaker NX and 2024 for Windows
- ↳ Presentations NX and 2024 for Windows
- ↳ BasicMaker NX and 2024 for Windows
- ↳ SoftMaker Office NX and 2024 for Mac
- ↳ SoftMaker Office NX and 2024 for Mac (General)
- ↳ TextMaker NX and 2024 for Mac
- ↳ PlanMaker NX and 2024 for Mac
- ↳ Presentations NX and 2024 for Mac
- ↳ SoftMaker Office NX and 2024 for Linux
- ↳ SoftMaker Office NX and 2024 for Linux (General)
- ↳ TextMaker NX and 2024 for Linux
- ↳ PlanMaker NX and 2024 for Linux
- ↳ Presentations NX and 2024 for Linux
- ↳ SoftMaker Office NX for iOS
- ↳ SoftMaker Office NX for iOS (General)
- ↳ TextMaker NX for iOS
- ↳ PlanMaker NX for iOS
- ↳ Presentations NX for iOS
- ↳ SoftMaker Office NX for Android
- ↳ SoftMaker Office NX for Android (General)
- ↳ TextMaker NX for Android
- ↳ PlanMaker NX for Android
- ↳ Presentations NX for Android
- SoftMaker Office 2021
- ↳ SoftMaker Office 2021 for Windows
- ↳ SoftMaker Office 2021 for Windows (General)
- ↳ TextMaker 2021 for Windows
- ↳ PlanMaker 2021 for Windows
- ↳ Presentations 2021 for Windows
- ↳ BasicMaker 2021 for Windows
- ↳ SoftMaker Office 2021 for Mac
- ↳ SoftMaker Office 2021 for Mac (General)
- ↳ TextMaker 2021 for Mac
- ↳ PlanMaker 2021 for Mac
- ↳ Presentations 2021 for Mac
- ↳ SoftMaker Office 2021 for Linux
- ↳ SoftMaker Office 2021 for Linux (General)
- ↳ TextMaker 2021 for Linux
- ↳ PlanMaker 2021 for Linux
- ↳ Presentations 2021 for Linux
- ↳ SoftMaker Office 2021 for Android
- ↳ SoftMaker Office 2021 for Android (General)
- ↳ TextMaker 2021 for Android
- ↳ PlanMaker 2021 for Android
- ↳ Presentations 2021 for Android
- ↳ SoftMaker Office 2021 for iOS
- ↳ General
- ↳ TextMaker 2021 for iOS
- ↳ PlanMaker 2021 for iOS
- ↳ Presentations 2021 for iOS
- FreeOffice 2024
- ↳ FreeOffice 2024 for Windows
- ↳ FreeOffice 2024 for Windows (General)
- ↳ FreeOffice TextMaker 2024 for Windows
- ↳ FreeOffice PlanMaker 2024 for Windows
- ↳ FreeOffice Presentations 2024 for Windows
- ↳ FreeOffice 2024 for Mac
- ↳ FreeOffice 2024 for Mac (General)
- ↳ FreeOffice TextMaker 2024 for Mac
- ↳ FreeOffice PlanMaker 2024 for Mac
- ↳ FreeOffice Presentations 2024 for Mac
- ↳ FreeOffice 2024 for Linux
- ↳ FreeOffice 2024 for Linux (General)
- ↳ FreeOffice TextMaker 2024 for Linux
- ↳ FreeOffice PlanMaker 2024 for Linux
- ↳ FreeOffice Presentations 2024 for Linux
- FreeOffice 2021
- ↳ FreeOffice 2021 for Windows
- ↳ FreeOffice 2021 for Windows (General)
- ↳ FreeOffice TextMaker 2021 for Windows
- ↳ FreeOffice PlanMaker 2021 for Windows
- ↳ FreeOffice Presentations 2021 for Windows
- ↳ FreeOffice 2021 for Mac
- ↳ FreeOffice 2021 for Mac (General)
- ↳ FreeOffice TextMaker 2021 for Mac
- ↳ FreeOffice PlanMaker 2021 for Mac
- ↳ FreeOffice Presentations 2021 for Mac
- ↳ FreeOffice 2021 for Linux
- ↳ FreeOffice 2021 for Linux (General)
- ↳ FreeOffice TextMaker 2021 for Linux
- ↳ FreeOffice PlanMaker 2021 for Linux
- ↳ FreeOffice Presentations 2021 for Linux
- ↳ FlexiPDF NX and 2025 for Windows
- ↳ FlexiPDF 2022
- ↳ FreePDF 2022
- Miscellaneous
- ↳ SoftMaker Fonts
- ↳ Water Cooler
- ↳ SoftMaker Office 2018 for Windows (General)
- ↳ TextMaker 2018 for Windows
- ↳ PlanMaker 2018 for Windows
- ↳ Presentations 2018 for Windows
- ↳ Thunderbird for Windows
- ↳ BasicMaker 2018 for Windows
- ↳ SoftMaker Office 2018 for Mac (General)
- ↳ TextMaker 2018 for Mac
- ↳ PlanMaker 2018 for Mac
- ↳ Presentations 2018 for Mac
- ↳ SoftMaker Office 2018 for Linux (General)
- ↳ TextMaker 2018 for Linux
- ↳ PlanMaker 2018 for Linux
- ↳ Presentations 2018 for Linux
- ↳ BETA SoftMaker Office 2024 for Windows
- ↳ BETA SoftMaker Office 2024 for Windows (general)
- ↳ BETA TextMaker 2024 for Windows
- ↳ BETA PlanMaker 2024 for Windows
- ↳ BETA Presentations 2024 for Windows
- ↳ BETA BasicMaker 2024 for Windows
- ↳ BETA SoftMaker Office 2024 for Mac
- ↳ BETA SoftMaker Office 2024 for Mac (general)
- ↳ BETA TextMaker 2024 for Mac
- ↳ BETA PlanMaker 2024 for Mac
- ↳ BETA Presentations 2024 for Mac
- ↳ BETA SoftMaker Office 2024 for Linux
- ↳ BETA SoftMaker Office 2024 for Linux (general)
- ↳ BETA TextMaker 2024 for Linux
- ↳ BETA PlanMaker 2024 for Linux
- ↳ BETA Presentations 2024 for Linux
- ↳ BETA SoftMaker Office NX for Android
- ↳ BETA SoftMaker Office NX for Android (general)
- ↳ BETA TextMaker NX for Android
- ↳ BETA PlanMaker NX for Android
- ↳ BETA Presentations NX for Android
- ↳ BETA SoftMaker Office NX for iOS
- ↳ BETA SoftMaker Office NX for iOS (general)
- ↳ BETA TextMaker NX for iOS
- ↳ BETA PlanMaker NX for iOS
- ↳ BETA Presentations NX for iOS