I have previously distributed a secure database which includes some hidden
tables.
These distributed databases reside on the many different users C drive at
multiple locations through out the state, under their Program Files folder.
One of the hidden tables needs updating. My intent was to create a
non-secure database that will contain only the updated hidden table. It
would be a small database, that when opened would show the hidden table. I
will provide simple instructions for the users on how to export the table
(which will display the table, although dimmed, because the Show Hidden
Objects will be True). I plan to place the database on a network drive that
they can all access (open) when they click on an email link.
Thanks to another site, it was suggested I write a function that would show
the hidden objects and then call that function via the runcode macro feature
naming the macro AutoExe. This idea worked GREAT!
Function Show_Hidden_Objects()
Application.SetOption "Show Hidden Objects", True
End Function
In the macro the "Action" used was "RunCode" and the "Function Name" was
"Show_Hidden_Objects()".
When the database opens, by default it displays "tables". For most of my
users it is very unlikely they will change the setting to display the hidden
(dimmed) macro or module.