View Single Post
 
Old 08-07-2019, 09:08 PM
Guessed's Avatar
Guessed Guessed is offline Windows 10 Office 2016
Expert
 
Join Date: Mar 2010
Location: Canberra/Melbourne Australia
Posts: 4,176
Guessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant future
Default

A macro solution is easily circumvented by disabling macros - which is the default for any file obtained from email or a website. They don't have to be a genius to avoid your restriction.

Perhaps you could lock an entire document and only enable editing via a userform. This at least forces regular users into running macros.
__________________
Andrew Lockton
Chrysalis Design, Melbourne Australia
Reply With Quote