Could it be as simple as you don't have macros enabled?

If no, what does the formula that causes the name error look like?



Philip Mark Hunt wrote:

I recently restructured my directories and now all the VBA code produces a
#NAME? error. It is all correctly located in Module 1 of the spreadsheet
where the code is being called from, and all worked quite happily before.

I have read and tried to understand and follow through on the advice against
similar posts to this one, but all the way I have things set up is exactly as
those advices direct.

Additional thoughts and advice would be welcome please.

With thanks in anticipation

Philip Hunt
--
Graewood Business Services, Kwinana, Perth, Western Australia

--

Dave Peterson