Excel/VB guru needed

[DrDoc]

I have this macro in Excel. I'm using the MSFlexGrid control to display some data. It all works fine, until I attempt to open the Excel file on a different machine. It then gives me an error when attempting to call the grid... and forces me to first go in and recreate the grid, and then run the macro again.

Any ideas on how to make the grid stay put, so I don't have to recreate/redefine each time?

[vkaryl]

Never used MSFlexGrid, but have you tried Protecting the spreadsheet (or the entire workbook) before you call it on another machine?

Also, I did have a few problems similar when trying to open spreadsheets with macros on machines with either older OR newer versions of Excel. Been a while now, but seems to me the solution was (going to an older machine) save as that version; can't remember if I had to Protect the workbook too or not.... Going to a new machine DID require Protecting the entire structure then saving in the newer version.

The other case where Protecting the whole shebang was an absolute necessity was when emailing complex table-structures.