Hi,
Is there any work-around for importing external data into a protected worksheet?
I have a worksheet that the user can use either to copy-paste a database or to use Excel's 'import external data' on the data menu. That database worksheet then feeds a dashboard. Problem is that there are formulas and ActiveX controls on that sheet that need to be protected, but once protection is engaged, the 'import external data' menu is disabled.
Is there any kind of trick or vba (oooh, that would have been fun during Halloween!) that will allow me to have both protection and import external data on the same sheet?
Thanks,
Lawrence
Is there any work-around for importing external data into a protected worksheet?
I have a worksheet that the user can use either to copy-paste a database or to use Excel's 'import external data' on the data menu. That database worksheet then feeds a dashboard. Problem is that there are formulas and ActiveX controls on that sheet that need to be protected, but once protection is engaged, the 'import external data' menu is disabled.
Is there any kind of trick or vba (oooh, that would have been fun during Halloween!) that will allow me to have both protection and import external data on the same sheet?
Thanks,
Lawrence