Hi guys,
I've got a spreadsheet that contains macros that remove columns and re-format the contents of a report. The idea is that the users copy the report (in xls format) and paste it in this workbook and run the macros by clicking on a button. My macros assume the first row contains the first record
My users are not computer savvy and pasting the report in my spreadsheet by selecting any cell other than A1 will mean that my macros will pretty much butcher the report and the results will be useless. My solution was to unlock only cell A1 and protect the whole spreadsheet:
This way the users will not have other option but to select cell A1. My plan is that when they select A1 that would unprotect the worksheet so that they would be able to paste the report. This is the code I had in mind (notice I used the SelectionChange event; that may not be the best option but my knowledge on programming is limited):Please Login or Register to view this content.
The problem is that when I paste the report that immediately triggers the SelectionChange event and gives me an error message ("Run-time error '13': Type mismatch"). Anybody know what could be happening here?Please Login or Register to view this content.
Thanks!
A.
Bookmarks