Excel 2010 - Creating functions in Sheet1 code window? or Module?

I noticed that I have to create a function in a module and not in sheet1 code window, sheet2 code window, etc.
How come?
Who is Participating?
Ejgil HedegaardCommented:
Functions can be made in sheet code modules, but can only be used in that sheet code module.
Functions in a module are Public, and can be used in all subs, unless declared Private for use in that module only.
Martin LissOlder than dirtCommented:
You should be able to create one in a sheet's code module. Can you show an example or post your workbook?
brothertruffle880Author Commented:
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.