Excel Enable Issues

In Progress Posted 5 years ago Paid on delivery
In Progress Paid on delivery

We have an Excel file with macros (XLSM). Download resource manager for excel from [login to view URL]

Problem happens across multiple versions of Excel and OS.

When downloaded from our website, or emailed, and the user tries to open the xlsm file, the first prompt is for:

ENABLE EDITING

After you click this, to enable editing, the screen goes blank pretty much but prompts second button for

ENABLE CONTENT

Enable Content is for enabling the VBA Macros.

At this point, Excel is frozen. And, you have to task manager to quit Excel. It seems actually frozen after enable editing even though you can still press the enable content button.

THEN – if you run Excel again and open file, it is FINE! Even though it was never ‘saved’ by the user.

However, this is NOT acceptable solution for new users downloading.

I tried under Trust Center, Protected View and Unchecked enable protected view for files originating from the internet, and this SOLVED the problem on MY pc but this is NOT acceptable for new users – to have to disable trust center settings.

And, I tried to Macro Security to enable ALL Macros and this worked as well but this is NOT acceptable for new users – to have to change macro security settings.

Any solution ideas?

Also -- tried to add a blank module, save, and exit.

Excel

Project ID: #17486855

About the project

5 proposals Remote project Active 5 years ago

5 freelancers are bidding on average $182 for this job

MohsanEijaz

I have 4 years experience in Excel VBA, VB, Google Spreadsheet, Google Spreadsheet Script, JS and more than 10 years in Excel. Thousands of different tasks has been fulfilled from a simple daily routines with formulas More

$250 USD in 3 days
(69 Reviews)
6.1
usmanhassan123

PhD in computer science having seven years of experience in Excel development.

$250 USD in 1 day
(53 Reviews)
6.0
paulodayto08

Hi Good Day! I think there's a conflict with your data and macro codes. Can i check your file? and let's see what help i give you to resolve you problem. I am an excel expert and doing excel report enhancement using More

$100 USD in 1 day
(16 Reviews)
3.5