2016 excel for mac compile error in hidden module

2016 Excel Compile Error In Hidden Module How To Avoid This

Its like the buttons are being disabled when I close or open the file.

I would like my Macro to just stop running if there is an error instead of an error message popping up.

I get this message three times, and once I am done clicking ok on all three of them, my spreadsheet works just fine.

I am converting it to a.csv file to import in to another program.

When I try to replace all commas (with nothing or with another character), I get the error message The formula you typed contains an error.

I have tried various formats (text, general, etc.) and various file types (.xls,.xlsx,.csv) and still get the same error.

2016 Excel Compile Error In Hidden Module How To Avoid This

Is there a way, perhaps through VBA, that I can not allow a user to save while somebody else is opening the document Other suggestions on how to avoid this error Thanks.

I have tried using the followhyperlink method but adobe acrobat opens very briefly then immediately closes.

People need to open the file to be able to sign up for various duty rosters.

And then for any others after that, get a message that the file is in use WITHOUT the option to open a read-only copy.

Our staff cant read and they keep opening additional copies of the file I have read about sharing the file and I dont think that would make things any better.

I have tried the usual way by hovering between the rows above and below until i get the double line but this does not happen.

I have also tried going through the Format - Row - Unhide option but this also doesnt work.

I only want one user to be able to make changes at a time (any other users would get a read-only).

For some reason it currently does not do this, and I have multiple users with the same doc open.

I had been using the form control buttons to run macros, but the boss wanted each button to have its own, different color.

So I removed the form control buttons and created new ActiveX command buttons.

I got into the button properties and set the background colors.

I added the Click code to run the macros when the user clicked the buttons.

Now when I open the workbook, the buttons dont work When I click them nothing happens.

No error message.

Nothing. If I right-click the button in Design Mode and select Properties, I get sheet properties not the button properties.

The odd thing is if I create a new button it works fine until I save and close the file.

2016 Excel For Mac Compile Error In Hidden Module