cannot get worksheet.codename

Add-in Express™ Support Service
That's what is more important than anything else

cannot get worksheet.codename
 
Ramesh Shrestha




Posts: 63
Joined: 2011-01-03
Can we get the worksheet.codename without using VB?
Tried this: https://www.add-in-express.com/forum/read.php?FID=5&TID=12315
But there is error "Access to visual basic project is not trusted ". So we have to check the checkbox in excel, which allows user interaction. Can we access the worksheet.codename without involving user interaction?
Posted 25 Feb, 2019 00:15:27 Top
Andrei Smolin


Add-in Express team


Posts: 16599
Joined: 2006-05-11
Hello Ramesh,

I don't think this is possible. A workaround would be to call a VBA method that returns that code name.

Regards from Belarus (GMT+3),

Andrei Smolin
Add-in Express Team Leader
Posted 25 Feb, 2019 01:50:02 Top