troubleshooting Question

Xlsm file odd security setting when created in Excel 2003

Avatar of ElrondCT
ElrondCTFlag for United States of America asked on
Microsoft ExcelWindows 7
4 Comments1 Solution416 ViewsLast Modified:
I have an Excel macro which converts a .prn text file to a .xlsm macro-enabled spreadsheet.  On a Windows 7 Home Premium machine with the Office Compability Pack installed, running Excel 2003, the spreadsheet created has an odd security setting: in the Security tab of Properties for the file (viewed in Windows Explorer/My Computer), the group "Everyone" is missing. The result is that I cannot view the file when I connect from another, networked computer. I have other macros which convert .prn files to .xls spreadsheets, and they do show the Everyone group, with Full Control permission enabled.

Checking a bit more, I get the same behavior (no Everyone group) if I open a .xls spreadsheet and save it as either .xlsx or .xlsm. I also notice that the icon in the folder listing is slightly different; there's a gold padlock superimposed on the Excel icon. The padlock disappears if I create the Everyone group in the Security tab and give it Full Control.

I don't have this problem when I run the macro in Excel 2007 on another Windows 7 computer, but I have no way to verify whether it's something unusual in one of the computers, or a difference between Excel 2003 and 2007.

I can't see anything in the Excel options tabs that would seem to relate to this, though I may just not be looking in the right place. Any ideas on how to make these worksheets automatically visible & enabled to all in the Everyone group?
ASKER CERTIFIED SOLUTION
Lucian Constantin
Trainer

Our community of experts have been thoroughly vetted for their expertise and industry experience.

Join our community to see this answer!
Unlock 1 Answer and 4 Comments.
Start Free Trial
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 1 Answer and 4 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros