I'm writing a Cocoa app and basically I have a window and I need to check if a sheet is open before I open another window. Google doesn't seem to know that one. How may I check if the sheet is open or not?
You could use set sh = ActiveSheet , or strShName = ActiveSheet.Name . Show activity on this post. Test for matching worksheet and workbook names.
What is this? With this code we can use =WorksheetExists(B3) to test any text string to see if it exists as a sheet name in the current workbook.
If you suspect the sheet you are viewing is protected, you can navigate to the Review tab on your Excel Ribbon and checkout the Protect buttons. If the first button's name is Unprotect Sheet, you know your ActiveSheet is currently protected.
-[NSWindow attachedSheet]
BOOL hasSheet = ([window attachedSheet] != nil);
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With