Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi
How we can restrict the sheet of viewing? i Have seen the Show Sheet tab?How can I apply the condition
over there.. what will be the conditions.......any example will be very greatfull...
Regards
Sikandar
I believe a common method is to define a Sheet Show condition that tests the qvuser() value.
-Rob
You may have any condition you wish to show the sheet...it could also be based on selection of a value from a list box or on QVUser() as mentioned by Rob. However QVUser() works with section access. If you dont have section access, you may use OSUser(). An example condition is
=OSUser() = 'domain\username'
Thanks
Amit
Hi
Thank You soo much Amit and Rob. i was able to acheive it through Section Access..
Regards
Sikandar
You can also achive this through the conditional show of the sheets.
I ve got a lot of sheets in my analizies. There are 4 groups of these sheet dependent on who need these analyzies from Analyzer level. I add the initial sheet. Then i put 4 buttons and write a macros which hide and show adequate sheets.
<code>
Sub show
set y = ActiveDocument.Variables("Marketing")
y.SetContent "0", true
end sub
sub market
set y = ActiveDocument.Variables("Marketing")
if y.GetContent.String="1" then
ActiveDocument.Variables("Marketing").SetContent "0",true
set button1 = ActiveDocument.getsheetobject("BU63")
set prop = button1.GetProperties
prop.Text.v = "Pokaz analizy marketingowe"
button1.SetProperties prop
else
ActiveDocument.Variables("Marketing").SetContent "1",true
set button1 = ActiveDocument.getsheetobject("BU63")
set prop = button1.GetProperties
prop.Text.v = "Ukryj analizy marketingowe"
button1.SetProperties prop
end if
end sub
</code>
Firstly you need to define a variable (in my case variable is marketing) then put this variable to show condition in sheet
<code>
Marketing=1
</code>
Sorry for my English. I didn't use it from years and now i have to to start again:)
Hi there!!!
Excellent answers in the blog. you guys are lifesavers.
I have a question: Can you use a varible value as a parameter for a function in a macro? I have set ch=ActiveDocument.GetSheetObject("CH29"), and I want to replace the "CH29" portion with the content of the variable vREP_ID. I tried ch=ActiveDocument.GetSheetObject(vREP_ID), but it didn't work.
muchas gracias!!!!
Mauricio Cervantes
You have to make an API call to get the variable value first.
str = ActiveDocument.GetVariable(varname).GetContent.String
SET ch=ActiveDocument.GetSheetObject(str )
ROB!!!!!!!!
You don't know it, but your comments have help me a lot!!!!
Thanks so much for your advice. It's just what I needed.
Hope to be able to pay back to the community one day!!!
saludos
Mauricio Cervantes