Excel Enable Issues

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:


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


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.

Taidot: Excel

Näytä lisää: excel 2016 crashing windows 10, excel not responding mac, excel not responding windows 10, excel problems and solutions, excel 2016 not responding windows 10, excel not responding when saving, excel not responding how to save, excel 2016 performance issues, view directory name files cells vba excel, view excel sheet form example net, unlock excel password protected cut paste vba, excel macro enable cutpaste, refresh spreadsheet view excel macro, excel view code, excel macros design view, excel vba enable refresh, vba macro excel enable paste protected sheet, macro excel enable paste cut, view myspace profile view counter without increasing, rid excel enable auto refresh

Tietoa työnantajasta:
( 0 arvostelua ) United States

Projektin tunnus: #17486855

5 freelanceria on tarjonnut keskimäärin %project_bid_stats_avg_sub_26% %project_currencyDetails_sign_sub_27% tähän työhön

$155 USD 1 päivässä
(64 arvostelua)

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 Lisää

$250 USD 3 päivässä
(69 arvostelua)

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

$250 USD 1 päivässä
(53 arvostelua)

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 Lisää

$100 USD 1 päivässä
(16 arvostelua)
$155 USD 10 päivässä
(0 arvostelua)