Project Libary

i have created a spreadsheet using a few lines of VB, the sheet is to be used by several users from a shared location, i created the sheet on my pc added the VB code and saved it in a shared location

only for the users to get this warning (ive attached a screenprint)

It's caused by users not having a library installed on their version of windows. At a guess you've either got or had something like a calender control in your worksheet - it isn't available on all set ups

Originally Posted by Kyle123

It's caused by users not having a library installed on their version of windows. At a guess you've either got or had something like a calender control in your worksheet - it isn't available on all set ups

any way to see if i have controls in or not

i have attached the sheet i created

It's the datepickets, though it appears you aren't using them now. Just remove the code (not really necessary - but tidies things up) and untick the reference then save it

sorted thanks alot