Forum Discussion
Dan_sltc
Apr 28, 2020Copper Contributor
Can't figure out how to eliminate file-spec prefix on my VBA macro
A lifetime ago I wrote assembler, C, and C++ but was not a VB developer. Being a small business owner now (and with Covid19 giving me downtime) I thought I'd try to automate a few things and found my...
JKPieterse
Apr 28, 2020Silver Contributor
Dan_sltc
May 01, 2020Copper Contributor
Jan, thanks for the link to the article, it was helpful.
If I understood my options correctly, I decided to not use the Add-in concept and instead copied the VBA code for the function into each spreadsheet that uses it and turned on password protection, so at least users and the eventual customer can use it with having to do anything.
That would make a database developer shake his head because now I'll have a maintenance issue going forward.