Hello all,
I would like to get some help in how to automatically assign the classification as internal document.
At my company we use some classification tool in excel called Secure Islands Classification, and whenever create new file it pop ups asking to set the classification, usually being internal.
My problem here is that i have some files that have lots of tabs, around 30-40 and i made a macro that splits the file, into many files, one per tab.
So basically macro will go tab by tab, and creating a file with the name of the tab and so on...
But, as you can imagine, is not as efficient if every tab pops the classification message to select internal. and is what i want to add in the code, some line that automatically selects internal and keeps going without my intervention 40 times or so..
Hope someone understands what i mean and have some idea in how to do this.
thanks in advance.
I would like to get some help in how to automatically assign the classification as internal document.
At my company we use some classification tool in excel called Secure Islands Classification, and whenever create new file it pop ups asking to set the classification, usually being internal.
My problem here is that i have some files that have lots of tabs, around 30-40 and i made a macro that splits the file, into many files, one per tab.
So basically macro will go tab by tab, and creating a file with the name of the tab and so on...
But, as you can imagine, is not as efficient if every tab pops the classification message to select internal. and is what i want to add in the code, some line that automatically selects internal and keeps going without my intervention 40 times or so..
Hope someone understands what i mean and have some idea in how to do this.
thanks in advance.
