Jan 22 2018 07:17 PM
I'm running Excel for Mac Version 16.9 (180116).
This is part of Office 2016 for Home & Student.
After the last security update, I have noticed several changes that are problems.
1) Some of my files will open as tiny windows in the lower left hand corner of my screen. However, if I save those particular files as ".xlsm" format and then try again, I don't have the problem when I open and save the file. Any clues how to have those .xls files open as they used to? I wonder if there's a certain feature of some of my files that's throwing things off because it doesn't happen with all my files?
2) Each time I do a save of these same particular files with extension ".xls", I get an alert asking me if I'm sure I want to save it in the older format ["Some features in your workbook might be lost if you save it as Excel 97-2004 Workbook (.xls)."]. Any clue what the feature could be? Perhaps a Macro I have created ?
3) When I try and save these .xls files with .xlsx format, I get an alert asking:
The following features cannot be saved in macro-free workbooks:
• VB project
To save a file with these features, click No, and then choose a macro-enabled file type in the File Type list.
[That's when I can successfully save when I save as .xlsm format]
What is this "VB project" and is there a way to "get rid of it" and still keep my macros ?
Thanks for your help!
Jan 22 2018 11:20 PM
Jan 24 2018 07:55 PM
Jan 25 2018 12:51 AM