Macro Enabled Worksheet Problem

[nkkr]

Hi Everyone,

I recently made a database type worksheet with a macro for searching the data. This works fine on my computer, however when i try to open the document on other computers I get a message saying Excel found unreadable content in '*******.xlsm' do you want to recover the contents of this workbook? So I select yes, however this disables all of my macros and makes them inaccessible and I cannot create new ones. If i select no, it simply closes the document. What can I do to make the document work on all computers?

Thanks,

 

[Andrew Poulsom]

Welcome to MrExcel.

Are you opening the workbook from the same location on all computers, ie a network share?

 

[nkkr]

Hi, Sorry for late reply,

I have it on a USB stick, it opens from the usb on my computer, however it will not open from the usb on others.

 

[Andrew Poulsom]

Does it open if you copy it to the computer's hard drive?

 

[nkkr]

Still comes up with the same message, even when copied onto the hard drive.

 

[Andrew Poulsom]

Does Excel report if anything was removed from the workbook? You may find this helpful:

http://www.mrexcel.com/forum/showthread.php?t=297605