Obtain file extension

Morning to all the good people of Excel Forum;

I'm in a bit of a situation. I have a file in the form of an Excel Macro-enabled templete. But when the user uses the file and then save, I don't want the user to have access to certain functions which I have already coded.

So, my request is: How do I identify in VBA if my file in use is actually an *.xltm file or something else?

The scenario I want to run is:

Please Login or Register  to view this content.

Any help will be greatly appreciated

Hello Jaques,

This UDF will return the extension of the open workbook. If it has not benn saved, the function returns an empty string.

Please Login or Register  to view this content.

Example

Please Login or Register  to view this content.

Hi JohnJohns,

Thanks for the reply, not entirely sure how this is suppose to work, but

Hi Leith,

Thanks, on the dot!