Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 06-25-2019, 08:13 PM
NoSparks NoSparks is offline One veryhidden sheet, one hidden sheet and two visible sheets - how to saveas into .xlsm workbook Windows 7 64bit One veryhidden sheet, one hidden sheet and two visible sheets - how to saveas into .xlsm workbook Office 2010 64bit
Excel Hobbyist
 
Join Date: Nov 2013
Location: British Columbia, Canada
Posts: 842
NoSparks is a glorious beacon of lightNoSparks is a glorious beacon of lightNoSparks is a glorious beacon of lightNoSparks is a glorious beacon of lightNoSparks is a glorious beacon of light
Default


Care to post the workbook ?
Reply With Quote
  #2  
Old 06-26-2019, 02:08 AM
kiwimtnbkr kiwimtnbkr is offline One veryhidden sheet, one hidden sheet and two visible sheets - how to saveas into .xlsm workbook Windows 10 One veryhidden sheet, one hidden sheet and two visible sheets - how to saveas into .xlsm workbook Office 2010 64bit
Advanced Beginner
One veryhidden sheet, one hidden sheet and two visible sheets - how to saveas into .xlsm workbook
 
Join Date: Oct 2017
Posts: 69
kiwimtnbkr is on a distinguished road
Default

hi NoSparks,

See the attached.

If my original request is looking like it's going to be a ton of work, or just not possible, then would it be possible to stop the UserForm initializing if it 'saw' that the file type that was trying to opened was .xlsm? Initialize the UserForm if .xltm - don't initialize the UserForm if .xlsm?

Note that all the sheets are currently 'protected' and the current password is 'A'.

Many thanks
Mike
Attached Files
File Type: xltm Report Template - for upload.xltm (296.1 KB, 8 views)
Reply With Quote
Reply



Similar Threads
Thread Thread Starter Forum Replies Last Post
One veryhidden sheet, one hidden sheet and two visible sheets - how to saveas into .xlsm workbook How to map number of sheets one line per sheet into one sheet abbani Excel 3 12-12-2016 04:10 AM
One veryhidden sheet, one hidden sheet and two visible sheets - how to saveas into .xlsm workbook Can a Data Source be one sheet in a multi-sheet Workbook nfotx Mail Merge 1 07-01-2015 12:55 AM
Workbook with daily active sheet MDMeyers Excel 1 01-10-2015 04:48 AM
One veryhidden sheet, one hidden sheet and two visible sheets - how to saveas into .xlsm workbook permanently unprotecting a sheet or workbook mrmagoo Excel 2 07-04-2012 08:12 PM
One veryhidden sheet, one hidden sheet and two visible sheets - how to saveas into .xlsm workbook How do I merge data from one sheet in a workbook out into multiple sheets nolesca Excel 4 06-07-2010 08:13 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 04:19 AM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2025, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2025 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft