ExcelBanter - Add Custom Objects to Sheet

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - Add Custom Objects to Sheet (https://www.excelbanter.com/excel-discussion-misc-queries/238663-add-custom-objects-sheet.html)

Vineeth

Add Custom Objects to Sheet

Hi,

iam developing a com addin for excel 2007 now i want to save my project
object into Excel hidden sheet

how can implement this via code?
Thanks

joel

Add Custom Objects to Sheet

Sheets("Sheet1").Visible = False

I don't know why excel uses hid when you are manually doing this on a
worksheet and uses invisible from VBA!!!!!!!!!!!!!!!!!

"Vineeth" wrote:

Hi,

iam developing a com addin for excel 2007 now i want to save my project
object into Excel hidden sheet

how can implement this via code?
Thanks

All times are GMT +1. The time now is 02:12 PM.