I have an Excel workbook with eight data connections to various SQL Server data sources, most of them stored procedures that return tables of data. The connections are set to refresh either when the workbook is opened or automatically when the contents of the cells that contain the SP parameters change.
Right now, if someone lacks the security access to view the data, the procedures come back empty and the user doesn't see any data. I've been asked to add processing that will give the user an explicit error message via MsgBox alerting them that their security access is insufficient. However, I can't seem to find any place in Excel where such processing can be implemented.
Has anyone else successfully accomplished this?
Right now, if someone lacks the security access to view the data, the procedures come back empty and the user doesn't see any data. I've been asked to add processing that will give the user an explicit error message via MsgBox alerting them that their security access is insufficient. However, I can't seem to find any place in Excel where such processing can be implemented.
Has anyone else successfully accomplished this?